/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.synjones.pay.serv.dao.repository;

import com.synjones.pay.serv.dao.bean.TransferDao;
import javax.transaction.Transactional;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

/**
 *
 * @author hsd
 */
public interface TansferDaoRepository extends JpaRepository<TransferDao, String>{
    @Query(value = "update synpay_transfer r set r.status_code = ?1,r.complete_time = ?2,r.serial_no = ?3,r.paytool_code = ?4, r.amount = ?5 where  r.order_id = ?6 ", nativeQuery = true)
    @Modifying
    @Transactional
    public int updateOrderStatusInfo(String statusCode,String completeTime,String serialNo,String paytoolCode, String amount, String orderId);
}
